initial look

Dataset statistics

Number of variables	17
Number of observations	14585
Missing cells	21956
Missing cells (%)	8.9%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	2.5 MiB
Average record size in memory	180.2 B

Variable types

Numeric	14
Categorical	3

Alerts

`id` is highly overall correlated with `country_id` and 1 other fields	High correlation
`match_api_id` is highly overall correlated with `season`	High correlation
`B365H` is highly overall correlated with `BWH` and 8 other fields	High correlation
`BWH` is highly overall correlated with `B365H` and 8 other fields	High correlation
`IWH` is highly overall correlated with `B365H` and 8 other fields	High correlation
`LBH` is highly overall correlated with `B365H` and 8 other fields	High correlation
`PSH` is highly overall correlated with `B365H` and 8 other fields	High correlation
`WHH` is highly overall correlated with `B365H` and 8 other fields	High correlation
`SJH` is highly overall correlated with `B365H` and 8 other fields	High correlation
`VCH` is highly overall correlated with `B365H` and 8 other fields	High correlation
`GBH` is highly overall correlated with `B365H` and 8 other fields	High correlation
`BSH` is highly overall correlated with `B365H` and 8 other fields	High correlation
`country_id` is highly overall correlated with `id` and 1 other fields	High correlation
`league_id` is highly overall correlated with `id` and 1 other fields	High correlation
`season` is highly overall correlated with `match_api_id`	High correlation
`PSH` has 7293 (50.0%) missing values	Missing
`SJH` has 3511 (24.1%) missing values	Missing
`GBH` has 5504 (37.7%) missing values	Missing
`BSH` has 5500 (37.7%) missing values	Missing
`home_team_api_id` is highly skewed (γ1 = 21.86459231)	Skewed
`away_team_api_id` is highly skewed (γ1 = 21.86459323)	Skewed
`season` is uniformly distributed	Uniform
`id` has unique values	Unique
`match_api_id` has unique values	Unique

Reproduction

Analysis started	2023-02-28 18:16:47.684155
Analysis finished	2023-02-28 18:17:10.983415
Duration	23.3 seconds
Software version	pandas-profiling vv3.6.3
Download configuration	config.json

id
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	14585
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	10739.324

Minimum	1729
Maximum	24557
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	227.9 KiB

Quantile statistics

Minimum	1729
5-th percentile	2458.2
Q1	5375
median	9021
Q3	12667
95-th percentile	23827.8
Maximum	24557
Range	22828
Interquartile range (IQR)	7292

Descriptive statistics

Standard deviation	6984.3738
Coefficient of variation (CV)	0.65035505
Kurtosis	-0.59158609
Mean	10739.324
Median Absolute Deviation (MAD)	3646
Skewness	0.82586204
Sum	1.5663304 × 10⁸
Variance	48781478
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1729	1	< 0.1%
11471	1	< 0.1%
11445	1	< 0.1%
11446	1	< 0.1%
11447	1	< 0.1%
11448	1	< 0.1%
11449	1	< 0.1%
11450	1	< 0.1%
11451	1	< 0.1%
11452	1	< 0.1%
Other values (14575)	14575	99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1729	1	< 0.1%
1730	1	< 0.1%
1731	1	< 0.1%
1732	1	< 0.1%
1733	1	< 0.1%
1734	1	< 0.1%
1735	1	< 0.1%
1736	1	< 0.1%
1737	1	< 0.1%
1738	1	< 0.1%

Value	Count	Frequency (%)
24557	1	< 0.1%
24556	1	< 0.1%
24555	1	< 0.1%
24554	1	< 0.1%
24553	1	< 0.1%
24552	1	< 0.1%
24551	1	< 0.1%
24550	1	< 0.1%
24549	1	< 0.1%
24548	1	< 0.1%

country_id
Categorical

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	227.9 KiB

1729	3040
4769	3040
21518	3040
10257	3017
7809	2448

Length

Max length	5
Median length	4
Mean length	4.4152897
Min length	4

Characters and Unicode

Total characters	64397
Distinct characters	9
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1729
2nd row	1729
3rd row	1729
4th row	1729
5th row	1729

Common Values

Value	Count	Frequency (%)
1729	3040	20.8%
4769	3040	20.8%
21518	3040	20.8%
10257	3017	20.7%
7809	2448	16.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1729	3040	20.8%
4769	3040	20.8%
21518	3040	20.8%
10257	3017	20.7%
7809	2448	16.8%

Most occurring characters

Value	Count	Frequency (%)
1	12137	18.8%
7	11545	17.9%
2	9097	14.1%
9	8528	13.2%
5	6057	9.4%
8	5488	8.5%
0	5465	8.5%
4	3040	4.7%
6	3040	4.7%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	64397	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	12137	18.8%
7	11545	17.9%
2	9097	14.1%
9	8528	13.2%
5	6057	9.4%
8	5488	8.5%
0	5465	8.5%
4	3040	4.7%
6	3040	4.7%

Most occurring scripts

Value	Count	Frequency (%)
Common	64397	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	12137	18.8%
7	11545	17.9%
2	9097	14.1%
9	8528	13.2%
5	6057	9.4%
8	5488	8.5%
0	5465	8.5%
4	3040	4.7%
6	3040	4.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	64397	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	12137	18.8%
7	11545	17.9%
2	9097	14.1%
9	8528	13.2%
5	6057	9.4%
8	5488	8.5%
0	5465	8.5%
4	3040	4.7%
6	3040	4.7%

league_id
Categorical

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	227.9 KiB

1729	3040
4769	3040
21518	3040
10257	3017
7809	2448

Length

Max length	5
Median length	4
Mean length	4.4152897
Min length	4

Characters and Unicode

Total characters	64397
Distinct characters	9
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1729
2nd row	1729
3rd row	1729
4th row	1729
5th row	1729

Common Values

Value	Count	Frequency (%)
1729	3040	20.8%
4769	3040	20.8%
21518	3040	20.8%
10257	3017	20.7%
7809	2448	16.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1729	3040	20.8%
4769	3040	20.8%
21518	3040	20.8%
10257	3017	20.7%
7809	2448	16.8%

Most occurring characters

Value	Count	Frequency (%)
1	12137	18.8%
7	11545	17.9%
2	9097	14.1%
9	8528	13.2%
5	6057	9.4%
8	5488	8.5%
0	5465	8.5%
4	3040	4.7%
6	3040	4.7%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	64397	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	12137	18.8%
7	11545	17.9%
2	9097	14.1%
9	8528	13.2%
5	6057	9.4%
8	5488	8.5%
0	5465	8.5%
4	3040	4.7%
6	3040	4.7%

Most occurring scripts

Value	Count	Frequency (%)
Common	64397	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	12137	18.8%
7	11545	17.9%
2	9097	14.1%
9	8528	13.2%
5	6057	9.4%
8	5488	8.5%
0	5465	8.5%
4	3040	4.7%
6	3040	4.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	64397	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	12137	18.8%
7	11545	17.9%
2	9097	14.1%
9	8528	13.2%
5	6057	9.4%
8	5488	8.5%
0	5465	8.5%
4	3040	4.7%
6	3040	4.7%

season
Categorical

HIGH CORRELATION UNIFORM

Distinct	8
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	227.9 KiB

2008/2009	1826
2009/2010	1826
2010/2011	1826
2012/2013	1826
2013/2014	1826
Other values (3)	5455

Length

Max length	9
Median length	9
Mean length	9
Min length	9

Characters and Unicode

Total characters	131265
Distinct characters	10
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2008/2009
2nd row	2008/2009
3rd row	2008/2009
4th row	2008/2009
5th row	2008/2009

Common Values

Value	Count	Frequency (%)
2008/2009	1826	12.5%
2009/2010	1826	12.5%
2010/2011	1826	12.5%
2012/2013	1826	12.5%
2013/2014	1826	12.5%
2015/2016	1826	12.5%
2014/2015	1825	12.5%
2011/2012	1804	12.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2008/2009	1826	12.5%
2009/2010	1826	12.5%
2010/2011	1826	12.5%
2012/2013	1826	12.5%
2013/2014	1826	12.5%
2015/2016	1826	12.5%
2014/2015	1825	12.5%
2011/2012	1804	12.4%

Most occurring characters

Value	Count	Frequency (%)
0	38300	29.2%
2	32800	25.0%
1	27322	20.8%
/	14585	11.1%
9	3652	2.8%
3	3652	2.8%
4	3651	2.8%
5	3651	2.8%
8	1826	1.4%
6	1826	1.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	116680	88.9%
Other Punctuation	14585	11.1%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	38300	32.8%
2	32800	28.1%
1	27322	23.4%
9	3652	3.1%
3	3652	3.1%
4	3651	3.1%
5	3651	3.1%
8	1826	1.6%
6	1826	1.6%

Other Punctuation

Value	Count	Frequency (%)
/	14585	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	131265	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	38300	29.2%
2	32800	25.0%
1	27322	20.8%
/	14585	11.1%
9	3652	2.8%
3	3652	2.8%
4	3651	2.8%
5	3651	2.8%
8	1826	1.4%
6	1826	1.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	131265	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	38300	29.2%
2	32800	25.0%
1	27322	20.8%
/	14585	11.1%
9	3652	2.8%
3	3652	2.8%
4	3651	2.8%
5	3651	2.8%
8	1826	1.4%
6	1826	1.4%

match_api_id
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	14585
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1198544.3

Minimum	483129
Maximum	2118418
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	227.9 KiB

Quantile statistics

Minimum	483129
5-th percentile	489392.2
Q1	705602
median	1216821
Q3	1709701
95-th percentile	2030112.8
Maximum	2118418
Range	1635289
Interquartile range (IQR)	1004099

Descriptive statistics

Standard deviation	494169.8
Coefficient of variation (CV)	0.41230833
Kurtosis	-1.1838785
Mean	1198544.3
Median Absolute Deviation (MAD)	492886
Skewness	0.23033563
Sum	1.7480769 × 10¹⁰
Variance	2.4420379 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
489042	1	< 0.1%
1083263	1	< 0.1%
1083149	1	< 0.1%
1083150	1	< 0.1%
1083154	1	< 0.1%
1083158	1	< 0.1%
1083160	1	< 0.1%
1083162	1	< 0.1%
1083166	1	< 0.1%
1083171	1	< 0.1%
Other values (14575)	14575	99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
483129	1	< 0.1%
483130	1	< 0.1%
483131	1	< 0.1%
483132	1	< 0.1%
483133	1	< 0.1%
483134	1	< 0.1%
483135	1	< 0.1%
483136	1	< 0.1%
483137	1	< 0.1%
483138	1	< 0.1%

Value	Count	Frequency (%)
2118418	1	< 0.1%
2060645	1	< 0.1%
2060644	1	< 0.1%
2060643	1	< 0.1%
2060642	1	< 0.1%
2060641	1	< 0.1%
2060640	1	< 0.1%
2060639	1	< 0.1%
2060638	1	< 0.1%
2060637	1	< 0.1%

home_team_api_id
Real number (ℝ)

Distinct	164
Distinct (%)	1.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	9513.4717

Minimum	4087
Maximum	208931
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	227.9 KiB

Quantile statistics

Minimum	4087
5-th percentile	8178
Q1	8535
median	8686
Q3	9869
95-th percentile	10260
Maximum	208931
Range	204844
Interquartile range (IQR)	1334

Descriptive statistics

Standard deviation	8097.7772
Coefficient of variation (CV)	0.85119055
Kurtosis	505.90825
Mean	9513.4717
Median Absolute Deviation (MAD)	509
Skewness	21.864592
Sum	1.3875398 × 10⁸
Variance	65573996
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10260	152	1.0%
9827	152	1.0%
9851	152	1.0%
8639	152	1.0%
8689	152	1.0%
8592	152	1.0%
9831	152	1.0%
9853	152	1.0%
9941	152	1.0%
9847	152	1.0%
Other values (154)	13065	89.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
4087	76	0.5%
4170	19	0.1%
6269	18	0.1%
6391	19	0.1%
7794	76	0.5%
7819	95	0.7%
7869	19	0.1%
7878	95	0.7%
7943	57	0.4%
8121	19	0.1%

Value	Count	Frequency (%)
208931	19	0.1%
108893	19	0.1%
10281	76	0.5%
10278	19	0.1%
10269	136	0.9%
10268	38	0.3%
10267	152	1.0%
10261	133	0.9%
10260	152	1.0%
10252	152	1.0%

away_team_api_id
Real number (ℝ)

Distinct	164
Distinct (%)	1.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	9513.6747

Minimum	4087
Maximum	208931
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	227.9 KiB

Quantile statistics

Minimum	4087
5-th percentile	8178
Q1	8535
median	8686
Q3	9869
95-th percentile	10260
Maximum	208931
Range	204844
Interquartile range (IQR)	1334

Descriptive statistics

Standard deviation	8097.7678
Coefficient of variation (CV)	0.8511714
Kurtosis	505.9084
Mean	9513.6747
Median Absolute Deviation (MAD)	509
Skewness	21.864593
Sum	1.3875695 × 10⁸
Variance	65573844
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
9748	152	1.0%
9831	152	1.0%
9941	152	1.0%
8636	152	1.0%
9847	152	1.0%
8639	152	1.0%
8592	152	1.0%
8686	152	1.0%
9827	152	1.0%
8564	152	1.0%
Other values (154)	13065	89.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
4087	76	0.5%
4170	19	0.1%
6269	18	0.1%
6391	19	0.1%
7794	76	0.5%
7819	95	0.7%
7869	19	0.1%
7878	95	0.7%
7943	57	0.4%
8121	19	0.1%

Value	Count	Frequency (%)
208931	19	0.1%
108893	19	0.1%
10281	76	0.5%
10278	19	0.1%
10269	136	0.9%
10268	38	0.3%
10267	152	1.0%
10261	133	0.9%
10260	152	1.0%
10252	152	1.0%

B365H
Real number (ℝ)

Distinct	118
Distinct (%)	0.8%
Missing	12
Missing (%)	0.1%
Infinite	0
Infinite (%)	0.0%
Mean	2.5956063

Minimum	1.04
Maximum	26
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	227.9 KiB

Quantile statistics

Minimum	1.04
5-th percentile	1.25
Q1	1.67
median	2.1
Q3	2.75
95-th percentile	6
Maximum	26
Range	24.96
Interquartile range (IQR)	1.08

Descriptive statistics

Standard deviation	1.7569991
Coefficient of variation (CV)	0.67691278
Kurtosis	23.559478
Mean	2.5956063
Median Absolute Deviation (MAD)	0.5
Skewness	3.9382983
Sum	37825.77
Variance	3.0870457
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2.1	696	4.8%
2	630	4.3%
2.5	506	3.5%
2.2	504	3.5%
1.91	498	3.4%
2.4	401	2.7%
1.44	396	2.7%
2.3	383	2.6%
2.25	382	2.6%
1.8	328	2.2%
Other values (108)	9849	67.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1.04	5	< 0.1%
1.05	17	0.1%
1.06	21	0.1%
1.07	12	0.1%
1.08	28	0.2%
1.09	9	0.1%
1.1	34	0.2%
1.11	14	0.1%
1.13	50	0.3%
1.14	56	0.4%

Value	Count	Frequency (%)
26	2	< 0.1%
23	1	< 0.1%
21	3	< 0.1%
19	5	< 0.1%
17	7	< 0.1%
15	24	0.2%
14	1	< 0.1%
13	41	0.3%
12	26	0.2%
11	23	0.2%

BWH
Real number (ℝ)

Distinct	220
Distinct (%)	1.5%
Missing	27
Missing (%)	0.2%
Infinite	0
Infinite (%)	0.0%
Mean	2.541709

Minimum	1.03
Maximum	34
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	227.9 KiB

Quantile statistics

Minimum	1.03
5-th percentile	1.25
Q1	1.7
median	2.1
Q3	2.7
95-th percentile	5.5
Maximum	34
Range	32.97
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	1.6254011
Coefficient of variation (CV)	0.63949141
Kurtosis	27.356785
Mean	2.541709
Median Absolute Deviation (MAD)	0.5
Skewness	3.9208926
Sum	37002.2
Variance	2.6419287
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2	479	3.3%
2.1	441	3.0%
2.05	434	3.0%
1.95	426	2.9%
2.15	396	2.7%
2.25	373	2.6%
2.3	357	2.4%
2.2	355	2.4%
2.4	349	2.4%
1.75	336	2.3%
Other values (210)	10612	72.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1.03	2	< 0.1%
1.04	1	< 0.1%
1.05	13	0.1%
1.06	15	0.1%
1.07	12	0.1%
1.08	33	0.2%
1.09	15	0.1%
1.1	28	0.2%
1.11	21	0.1%
1.12	40	0.3%

Value	Count	Frequency (%)
34	1	< 0.1%
21	3	< 0.1%
19	1	< 0.1%
18	1	< 0.1%
17	2	< 0.1%
16.5	2	< 0.1%
16	3	< 0.1%
15.5	2	< 0.1%
15	3	< 0.1%
14.5	2	< 0.1%

IWH
Real number (ℝ)

Distinct	146
Distinct (%)	1.0%
Missing	45
Missing (%)	0.3%
Infinite	0
Infinite (%)	0.0%
Mean	2.4544746

Minimum	1.05
Maximum	20
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	227.9 KiB

Quantile statistics

Minimum	1.05
5-th percentile	1.25
Q1	1.7
median	2.1
Q3	2.6
95-th percentile	5.2
Maximum	20
Range	18.95
Interquartile range (IQR)	0.9

Descriptive statistics

Standard deviation	1.4342161
Coefficient of variation (CV)	0.58432715
Kurtosis	18.017313
Mean	2.4544746
Median Absolute Deviation (MAD)	0.45
Skewness	3.5009461
Sum	35688.06
Variance	2.0569759
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2	903	6.2%
2.1	849	5.8%
2.2	794	5.4%
1.9	691	4.7%
2.3	683	4.7%
2.4	556	3.8%
1.8	513	3.5%
2.5	470	3.2%
2.6	463	3.2%
1.85	392	2.7%
Other values (136)	8226	56.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1.05	14	0.1%
1.07	33	0.2%
1.08	8	0.1%
1.1	46	0.3%
1.11	7	< 0.1%
1.12	60	0.4%
1.13	2	< 0.1%
1.15	85	0.6%
1.17	64	0.4%
1.18	7	< 0.1%

Value	Count	Frequency (%)
20	2	< 0.1%
15	4	< 0.1%
14	9	0.1%
13	9	0.1%
12.5	5	< 0.1%
12	17	0.1%
11.5	2	< 0.1%
11	13	0.1%
10.5	5	< 0.1%
10.3	9	0.1%

LBH
Real number (ℝ)

Distinct	119
Distinct (%)	0.8%
Missing	17
Missing (%)	0.1%
Infinite	0
Infinite (%)	0.0%
Mean	2.5125048

Minimum	1.04
Maximum	26
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	227.9 KiB

Quantile statistics

Minimum	1.04
5-th percentile	1.25
Q1	1.67
median	2.1
Q3	2.7
95-th percentile	5.5
Maximum	26
Range	24.96
Interquartile range (IQR)	1.03

Descriptive statistics

Standard deviation	1.6065461
Coefficient of variation (CV)	0.63942012
Kurtosis	23.038864
Mean	2.5125048
Median Absolute Deviation (MAD)	0.48
Skewness	3.8605401
Sum	36602.17
Variance	2.5809905
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2.1	687	4.7%
2	653	4.5%
2.2	547	3.8%
2.25	498	3.4%
1.8	465	3.2%
2.5	461	3.2%
1.91	435	3.0%
2.4	356	2.4%
2.38	337	2.3%
1.83	332	2.3%
Other values (109)	9797	67.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1.04	3	< 0.1%
1.05	12	0.1%
1.06	6	< 0.1%
1.07	21	0.1%
1.08	25	0.2%
1.09	19	0.1%
1.1	33	0.2%
1.11	19	0.1%
1.12	36	0.2%
1.13	5	< 0.1%

Value	Count	Frequency (%)
26	1	< 0.1%
23	1	< 0.1%
21	1	< 0.1%
19	3	< 0.1%
17	5	< 0.1%
15	14	0.1%
13	27	0.2%
12	28	0.2%
11	23	0.2%
10.5	1	< 0.1%

PSH
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	795
Distinct (%)	10.9%
Missing	7293
Missing (%)	50.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.7874011

Minimum	1.04
Maximum	36
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	227.9 KiB

Quantile statistics

Minimum	1.04
5-th percentile	1.26
Q1	1.71
median	2.18
Q3	2.94
95-th percentile	6.55
Maximum	36
Range	34.96
Interquartile range (IQR)	1.23

Descriptive statistics

Standard deviation	2.1918452
Coefficient of variation (CV)	0.78634009
Kurtosis	31.226705
Mean	2.7874011
Median Absolute Deviation (MAD)	0.55
Skewness	4.5013018
Sum	20325.729
Variance	4.8041855
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1.93	67	0.5%
1.83	57	0.4%
1.85	56	0.4%
2.08	56	0.4%
1.88	55	0.4%
1.65	54	0.4%
1.47	54	0.4%
2.1	53	0.4%
2.01	50	0.3%
2.07	50	0.3%
Other values (785)	6740	46.2%
(Missing)	7293	50.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1.04	1	< 0.1%
1.05	1	< 0.1%
1.06	9	0.1%
1.07	11	0.1%
1.08	10	0.1%
1.09	13	0.1%
1.1	19	0.1%
1.11	15	0.1%
1.12	9	0.1%
1.13	16	0.1%

Value	Count	Frequency (%)
36	1	< 0.1%
31.13	1	< 0.1%
25.51	1	< 0.1%
23.6	1	< 0.1%
23	1	< 0.1%
22.4	1	< 0.1%
22.3	1	< 0.1%
21.2	1	< 0.1%
21.1	1	< 0.1%
21.08	1	< 0.1%

WHH
Real number (ℝ)

Distinct	116
Distinct (%)	0.8%
Missing	17
Missing (%)	0.1%
Infinite	0
Infinite (%)	0.0%
Mean	2.5692854

Minimum	1.02
Maximum	26
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	227.9 KiB

Quantile statistics

Minimum	1.02
5-th percentile	1.29
Q1	1.7
median	2.15
Q3	2.7
95-th percentile	5.5
Maximum	26
Range	24.98
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	1.6885185
Coefficient of variation (CV)	0.65719383
Kurtosis	23.850584
Mean	2.5692854
Median Absolute Deviation (MAD)	0.48
Skewness	3.9699912
Sum	37429.35
Variance	2.8510948
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2.5	536	3.7%
2	515	3.5%
2.1	504	3.5%
2.3	497	3.4%
2.4	485	3.3%
2.2	444	3.0%
1.91	430	2.9%
2.05	395	2.7%
2.25	381	2.6%
1.44	370	2.5%
Other values (106)	10011	68.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1.02	1	< 0.1%
1.04	2	< 0.1%
1.05	9	0.1%
1.06	14	0.1%
1.07	7	< 0.1%
1.08	36	0.2%
1.1	45	0.3%
1.11	22	0.2%
1.12	26	0.2%
1.14	72	0.5%

Value	Count	Frequency (%)
26	1	< 0.1%
23	1	< 0.1%
21	4	< 0.1%
19	2	< 0.1%
17	8	0.1%
15	25	0.2%
13	19	0.1%
12	38	0.3%
11	33	0.2%
10.5	2	< 0.1%

SJH
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	124
Distinct (%)	1.1%
Missing	3511
Missing (%)	24.1%
Infinite	0
Infinite (%)	0.0%
Mean	2.5335371

Minimum	1.04
Maximum	23
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	227.9 KiB

Quantile statistics

Minimum	1.04
5-th percentile	1.25
Q1	1.67
median	2.1
Q3	2.7
95-th percentile	5.5
Maximum	23
Range	21.96
Interquartile range (IQR)	1.03

Descriptive statistics

Standard deviation	1.6279278
Coefficient of variation (CV)	0.64255141
Kurtosis	19.63822
Mean	2.5335371
Median Absolute Deviation (MAD)	0.48
Skewness	3.6768224
Sum	28056.39
Variance	2.6501491
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2.1	589	4.0%
2	491	3.4%
2.2	434	3.0%
2.5	394	2.7%
1.83	313	2.1%
2.25	308	2.1%
1.73	306	2.1%
2.38	301	2.1%
2.3	297	2.0%
1.44	295	2.0%
Other values (114)	7346	50.4%
(Missing)	3511	24.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1.04	1	< 0.1%
1.05	10	0.1%
1.06	10	0.1%
1.07	10	0.1%
1.08	18	0.1%
1.09	7	< 0.1%
1.1	18	0.1%
1.11	19	0.1%
1.12	3	< 0.1%
1.13	24	0.2%

Value	Count	Frequency (%)
23	1	< 0.1%
21	1	< 0.1%
19	1	< 0.1%
17	3	< 0.1%
15	14	0.1%
14	1	< 0.1%
13	24	0.2%
12	10	0.1%
11	34	0.2%
10.5	1	< 0.1%

VCH
Real number (ℝ)

Distinct	156
Distinct (%)	1.1%
Missing	30
Missing (%)	0.2%
Infinite	0
Infinite (%)	0.0%
Mean	2.6429395

Minimum	1.03
Maximum	36
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	227.9 KiB

Quantile statistics

Minimum	1.03
5-th percentile	1.25
Q1	1.7
median	2.15
Q3	2.8
95-th percentile	6
Maximum	36
Range	34.97
Interquartile range (IQR)	1.1

Descriptive statistics

Standard deviation	1.916398
Coefficient of variation (CV)	0.72510095
Kurtosis	36.030799
Mean	2.6429395
Median Absolute Deviation (MAD)	0.5
Skewness	4.6880719
Sum	38467.985
Variance	3.6725812
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2.1	547	3.8%
2	513	3.5%
2.2	474	3.2%
2.3	405	2.8%
2.5	404	2.8%
2.05	394	2.7%
2.25	379	2.6%
2.4	308	2.1%
2.15	308	2.1%
1.8	302	2.1%
Other values (146)	10521	72.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1.03	2	< 0.1%
1.04	5	< 0.1%
1.05	6	< 0.1%
1.06	29	0.2%
1.07	13	0.1%
1.08	9	0.1%
1.083	1	< 0.1%
1.09	23	0.2%
1.1	26	0.2%
1.11	18	0.1%

Value	Count	Frequency (%)
36	1	< 0.1%
31	1	< 0.1%
29	2	< 0.1%
26	1	< 0.1%
23	2	< 0.1%
22	1	< 0.1%
21	4	< 0.1%
20	3	< 0.1%
19	7	< 0.1%
18	7	< 0.1%

GBH
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	150
Distinct (%)	1.7%
Missing	5504
Missing (%)	37.7%
Infinite	0
Infinite (%)	0.0%
Mean	2.4724259

Minimum	1.05
Maximum	21
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	227.9 KiB

Quantile statistics

Minimum	1.05
5-th percentile	1.27
Q1	1.7
median	2.1
Q3	2.63
95-th percentile	5
Maximum	21
Range	19.95
Interquartile range (IQR)	0.93

Descriptive statistics

Standard deviation	1.4547078
Coefficient of variation (CV)	0.58837264
Kurtosis	19.317445
Mean	2.4724259
Median Absolute Deviation (MAD)	0.45
Skewness	3.5702975
Sum	22452.1
Variance	2.1161747
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2.1	425	2.9%
2	410	2.8%
2.2	278	1.9%
2.4	266	1.8%
2.3	261	1.8%
2.5	253	1.7%
1.95	235	1.6%
1.9	228	1.6%
2.25	225	1.5%
1.8	217	1.5%
Other values (140)	6283	43.1%
(Missing)	5504	37.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1.05	3	< 0.1%
1.06	10	0.1%
1.07	6	< 0.1%
1.08	6	< 0.1%
1.09	5	< 0.1%
1.1	17	0.1%
1.11	1	< 0.1%
1.12	18	0.1%
1.13	9	0.1%
1.14	9	0.1%

Value	Count	Frequency (%)
21	1	< 0.1%
17	3	< 0.1%
16	1	< 0.1%
15	3	< 0.1%
14	1	< 0.1%
13	8	0.1%
12	5	< 0.1%
11.5	3	< 0.1%
11	16	0.1%
10.5	5	< 0.1%

BSH
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	96
Distinct (%)	1.1%
Missing	5500
Missing (%)	37.7%
Infinite	0
Infinite (%)	0.0%
Mean	2.4657259

Minimum	1.04
Maximum	17
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	227.9 KiB

Quantile statistics

Minimum	1.04
5-th percentile	1.29
Q1	1.67
median	2.1
Q3	2.6
95-th percentile	5
Maximum	17
Range	15.96
Interquartile range (IQR)	0.93

Descriptive statistics

Standard deviation	1.4605436
Coefficient of variation (CV)	0.59233818
Kurtosis	18.447148
Mean	2.4657259
Median Absolute Deviation (MAD)	0.43
Skewness	3.5678767
Sum	22401.12
Variance	2.1331876
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2.1	414	2.8%
2	383	2.6%
2.5	340	2.3%
1.91	317	2.2%
2.3	304	2.1%
1.83	299	2.1%
2.4	296	2.0%
2.2	281	1.9%
2.25	277	1.9%
1.44	252	1.7%
Other values (86)	5922	40.6%
(Missing)	5500	37.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1.04	1	< 0.1%
1.05	1	< 0.1%
1.06	7	< 0.1%
1.07	11	0.1%
1.08	10	0.1%
1.1	12	0.1%
1.11	11	0.1%
1.12	22	0.2%
1.14	40	0.3%
1.17	59	0.4%

Value	Count	Frequency (%)
17	5	< 0.1%
15	4	< 0.1%
13	7	< 0.1%
12	12	0.1%
11	21	0.1%
10	22	0.2%
9.5	3	< 0.1%
9	27	0.2%
8.5	26	0.2%
8	22	0.2%

Auto

Heatmap
Table

	id	match_api_id	home_team_api_id	away_team_api_id	B365H	BWH	IWH	LBH	PSH	WHH	SJH	VCH	GBH	BSH	country_id	league_id	season
id	1.000	0.293	-0.085	-0.084	-0.031	-0.018	-0.019	-0.021	-0.024	-0.023	-0.026	-0.021	-0.025	-0.025	0.860	0.860	0.252
match_api_id	0.293	1.000	-0.026	-0.026	0.024	0.048	0.039	0.057	0.022	0.062	0.001	0.058	-0.006	0.008	0.000	0.000	1.000
home_team_api_id	-0.085	-0.026	1.000	-0.029	-0.052	-0.054	-0.057	-0.057	-0.049	-0.054	-0.057	-0.053	-0.063	-0.064	0.069	0.069	0.093
away_team_api_id	-0.084	-0.026	-0.029	1.000	0.055	0.056	0.060	0.056	0.055	0.054	0.060	0.053	0.061	0.061	0.069	0.069	0.093
B365H	-0.031	0.024	-0.052	0.055	1.000	0.995	0.990	0.993	0.998	0.995	0.995	0.996	0.997	0.995	0.073	0.073	0.027
BWH	-0.018	0.048	-0.054	0.056	0.995	1.000	0.991	0.993	0.997	0.994	0.993	0.995	0.996	0.994	0.076	0.076	0.020
IWH	-0.019	0.039	-0.057	0.060	0.990	0.991	1.000	0.990	0.989	0.988	0.989	0.988	0.990	0.990	0.084	0.084	0.034
LBH	-0.021	0.057	-0.057	0.056	0.993	0.993	0.990	1.000	0.995	0.994	0.991	0.994	0.992	0.992	0.077	0.077	0.032
PSH	-0.024	0.022	-0.049	0.055	0.998	0.997	0.989	0.995	1.000	0.997	0.997	0.999	0.996	0.995	0.075	0.075	0.029
WHH	-0.023	0.062	-0.054	0.054	0.995	0.994	0.988	0.994	0.997	1.000	0.992	0.996	0.994	0.993	0.078	0.078	0.034
SJH	-0.026	0.001	-0.057	0.060	0.995	0.993	0.989	0.991	0.997	0.992	1.000	0.992	0.994	0.993	0.090	0.090	0.023
VCH	-0.021	0.058	-0.053	0.053	0.996	0.995	0.988	0.994	0.999	0.996	0.992	1.000	0.994	0.994	0.075	0.075	0.030
GBH	-0.025	-0.006	-0.063	0.061	0.997	0.996	0.990	0.992	0.996	0.994	0.994	0.994	1.000	0.995	0.085	0.085	0.024
BSH	-0.025	0.008	-0.064	0.061	0.995	0.994	0.990	0.992	0.995	0.993	0.993	0.994	0.995	1.000	0.087	0.087	0.014
country_id	0.860	0.000	0.069	0.069	0.073	0.076	0.084	0.077	0.075	0.078	0.090	0.075	0.085	0.087	1.000	1.000	0.000
league_id	0.860	0.000	0.069	0.069	0.073	0.076	0.084	0.077	0.075	0.078	0.090	0.075	0.085	0.087	1.000	1.000	0.000
season	0.252	1.000	0.093	0.093	0.027	0.020	0.034	0.032	0.029	0.034	0.023	0.030	0.024	0.014	0.000	0.000	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	id	country_id	league_id	season	match_api_id	home_team_api_id	away_team_api_id	B365H	BWH	IWH	LBH	PSH	WHH	SJH	VCH	GBH	BSH
1728	1729	1729	1729	2008/2009	489042	10260	10261	1.29	1.30	1.30	1.25	NaN	1.25	1.25	1.28	1.30	1.29
1729	1730	1729	1729	2008/2009	489043	9825	8659	1.20	1.22	1.20	1.20	NaN	1.17	1.20	1.25	1.22	1.22
1730	1731	1729	1729	2008/2009	489044	8472	8650	5.50	5.00	4.50	4.50	NaN	5.50	4.33	5.50	5.00	4.50
1731	1732	1729	1729	2008/2009	489045	8654	8528	1.91	1.90	1.80	1.80	NaN	1.83	1.91	1.90	1.91	1.91
1732	1733	1729	1729	2008/2009	489046	10252	8456	1.91	1.95	2.00	1.83	NaN	1.91	1.91	1.90	1.91	1.91
1733	1734	1729	1729	2008/2009	489047	8668	8655	2.00	1.85	2.00	1.80	NaN	1.95	2.00	2.05	2.00	2.00
1734	1735	1729	1729	2008/2009	489048	8549	8586	3.20	2.80	2.90	2.80	NaN	2.90	2.88	3.20	3.00	2.80
1735	1736	1729	1729	2008/2009	489049	8559	10194	1.83	1.75	1.75	1.73	NaN	1.80	1.80	1.85	1.83	1.80
1736	1737	1729	1729	2008/2009	489050	8667	9879	2.60	2.45	2.40	2.40	NaN	2.50	2.38	2.60	2.60	2.60
1737	1738	1729	1729	2008/2009	489051	8455	8462	1.33	1.30	1.30	1.29	NaN	1.30	1.25	1.33	1.33	1.33

	id	country_id	league_id	season	match_api_id	home_team_api_id	away_team_api_id	B365H	BWH	IWH	LBH	PSH	WHH	SJH	VCH	GBH	BSH
24547	24548	21518	21518	2015/2016	2030162	8634	8372	1.11	1.11	1.10	1.11	1.13	1.14	NaN	1.11	NaN	NaN
24548	24549	21518	21518	2015/2016	2030163	8302	8305	1.44	1.48	1.50	1.44	1.50	1.50	NaN	1.50	NaN	NaN
24549	24550	21518	21518	2015/2016	2030164	8306	10205	3.50	3.25	3.30	3.50	3.72	3.50	NaN	3.60	NaN	NaN
24550	24551	21518	21518	2015/2016	2030165	9910	8633	3.80	3.90	3.80	3.60	4.02	3.75	NaN	3.90	NaN	NaN
24551	24552	21518	21518	2015/2016	2030166	8581	8560	2.63	2.70	2.60	2.62	2.78	2.70	NaN	2.75	NaN	NaN
24552	24553	21518	21518	2015/2016	2030167	9906	10267	1.57	1.57	1.65	1.57	1.58	1.62	NaN	1.57	NaN	NaN
24553	24554	21518	21518	2015/2016	2030168	9864	9783	2.25	2.35	2.20	2.25	2.36	2.38	NaN	2.30	NaN	NaN
24554	24555	21518	21518	2015/2016	2030169	8315	9869	1.53	1.55	1.60	1.50	1.55	1.57	NaN	1.55	NaN	NaN
24555	24556	21518	21518	2015/2016	2030170	7878	8603	2.30	2.35	2.40	2.30	2.34	2.40	NaN	2.30	NaN	NaN
24556	24557	21518	21518	2015/2016	2030171	8370	8558	2.20	2.25	2.30	2.10	2.20	2.20	NaN	2.20	NaN	NaN

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Other Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Interactions

Correlations

Missing values

Sample